//
//  LJHFMData.h
//  HEARME
//
//  Created by mac on 16/2/24.
//  Copyright © 2016年 dllo. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "FMDatabase.h"

@interface LJHFMData : NSObject

@property (nonatomic, retain)FMDatabase *db;

+(instancetype)shareFMDB;

-(void)openDB;

-(void)openDBandCreate;


//专辑
-(void)dropTableAlbums;

-(void)insertAlbumData:(LJHAlbumModel *)album;

-(NSMutableArray *)selectAlbumData;

-(NSMutableArray *)selectAlbumIdData;

-(void)deleteByAlbumId:(NSString *)Id;

//声音

-(void)dropTableTracks;
-(void)insertTrackData:(LJHAlbumModel *)track;
-(NSMutableArray *)selectTrackData;
-(NSMutableArray *)selectTrackIDData;
-(void)deleteByTrackId:(NSString *)Id;
-(NSMutableArray *)selectTrackImageData;
-(NSMutableArray *)selectTrackNameData;




@end
